<?php

/**
 * 留言记录
 * SQL 语句：
CREATE TABLE `test`.`note` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id' , `username` VARCHAR(64) NOT NULL COMMENT '用户名' , `message` VARCHAR(512) NOT NULL COMMENT '留言内容' , `create_time` INT(10) UNSIGNED NOT NULL COMMENT '创建时间' , `update_time` INT(10) UNSIGNED NOT NULL COMMENT '更新时间' , PRIMARY KEY (`id`), INDEX `idx_create_time` (`create_time`)) ENGINE = InnoDB CHARSET=utf8mb4 COLLATE utf8mb4_general_ci COMMENT = '用户留言表';
 */
return array(
    'table' => array(
        'name'     => 'note',
        'pk'       => 'id',
        'fields'   => array(
            'id',
            'username',
            'message',
            'create_time',
            'update_time',
        ),
        'required' => array('username', 'message'),
        'default'  => array(
            'create_time' => time(),
            'update_time' => time(),
        ),
        'encode_fields' => array(),
    )
);